USE [JJMC_BPMQA]
GO

/****** Object:  View [dbo].[UserProfiles]    Script Date: 4/15/2020 1:37:02 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

create view [dbo].[UserProfiles] as
select 
field0001 as Id,
field0002 as UserName,	
field0003 as UserEmail,
field0004 as UserCompany,
field0005 as UserBU,
field0006 as UserCode,
field0007 as UserPassword,
field0008 as SIMSID,
field0009 as LinkSIMSTime,
field0010 as IsDeleted,
field0011 as IsActived,
field0012 as UserType,
field0013 as DepartmentId,
field0014 as Roleld,
field0015 as CreaterId,
field0016 as CreateTime,
field0017 as UpdaterId,
field0018 as UpdateTime,
field0019 as PasswordChangedTime,
field0020 as Department_Id,
field0021 as Role_Id,
field0022 as IsInitialized,
field0023 as SubDept,
field0025 as PwdChangeToken,
field0026 as PwdChangeTime,
field0027 as CompassRole,
field0028 as LastConfirmedContactLnfoByDistributor
from formmain_0903

GO

